"192.168.0.1:sipop" Previous topic Chapter index Next topic

PRODUCTOS_BD

 

 

Descriptions

There is no desription for trigger PRODUCTOS_BD

 

Definition


CREATE TRIGGER PRODUCTOS_BD FOR PRODUCTOS ACTIVE
BEFORE DELETE POSITION 0
AS
declare variable HIJO INTEGER;
BEGIN
  /* Trigger body */
  SELECT COUNT (ID_PRODUCTOS) FROM PRODUCTOS
         WHERE
           ID_PADRE_PRODUCTO = OLD.ID_PRODUCTOS
       INTO:HIJO;
  if (HIJO>0) then
  BEGIN
      EXCEPTION exception_hijoexiste;
  END

  
  
END

    This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m. Previous topic Chapter index Next topic